CREATE VIEW [dbo].[vSoaGroupMemberSummaryOrganization]
WITH SCHEMABINDING
AS
    SELECT  CAST('ORGRELATIONSHIP-' + [n].[CO_ID] + ':' + [n].[ID] AS VARCHAR(50)) AS [GroupMemberId],
            CAST('ORGRELATIONSHIP-' + [n].[CO_ID] AS VARCHAR(50)) AS [GroupId],
            [n].[ID] AS PartyId,
            [n].[FULL_NAME] AS [PartyName],
            [n].[CO_ID]
      FROM  [dbo].[Name] AS [n]
     WHERE  [n].[CO_ID] != ''


GO
CREATE UNIQUE CLUSTERED INDEX [PK_vSoaGroupMemberSummaryOrganization] ON [dbo].[vSoaGroupMemberSummaryOrganization] ([GroupMemberId]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_vSoaGroupMemberSummaryOrganization_GroupId] ON [dbo].[vSoaGroupMemberSummaryOrganization] ([GroupId]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_vSoaGroupMemberSummaryOrganization_PartyId] ON [dbo].[vSoaGroupMemberSummaryOrganization] ([PartyId]) ON [PRIMARY]
GO